Occupation information for Data Warehousing Specialists District Of Columbia

description

Design, model, or implement corporate data warehousing activities. Program and configure warehouses of database information and provide support to warehouse users.

Compare Skills
details

Currently Employed: 940

Projected Annual Job Openings: 80

Typical Hourly Wage: $55.97 - $81.83

Typical Annual Salary: $116,420 - $170,210

See Job Listings (21) Find Businesses
typical training

Typical education needed for entry: Bachelor's degree

Typical work experience needed for a job in this occupation: Less than 5 years work experience

Typical on-the-job training once you have a job in this occupation: No on-the-job training

Find Training
typical job duties
  • Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
  • Verify the structure, accuracy, or quality of warehouse data.
  • Map data between source systems, data warehouses, and data marts.
  • Develop and implement data extraction procedures from other systems, such as administration, billing, or claims.
  • Design and implement warehouse database structures.
  • Develop or maintain standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases.
  • Provide or coordinate troubleshooting support for data warehouses.
  • Write new programs or modify existing programs to meet customer requirements, using current programming languages and technologies.
  • Design, implement, or operate comprehensive data warehouse systems to balance optimization of data access with batch loading and resource utilization factors, according to customer requirements.
  • Perform system analysis, data analysis or programming, using a variety of computer languages and procedures.
tools & technology
Tools:
  • Computer servers
  • Desktop computers
  • High end computer servers
  • Mainframe computers
  • Notebook computers

Technology:
  • Data base management system software
  • Data base user interface and query software
  • Development environment software
  • Metadata management software
  • Operating system software